/*
 Navicat Premium Data Transfer

 Source Server         : 本机mysql
 Source Server Type    : MySQL
 Source Server Version : 80028
 Source Host           : localhost:3306
 Source Schema         : user_test

 Target Server Type    : MySQL
 Target Server Version : 80028
 File Encoding         : 65001

 Date: 07/03/2022 22:27:20
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for extend_word
-- ----------------------------
DROP TABLE IF EXISTS `extend_word`;
CREATE TABLE `extend_word` (
  `id` int NOT NULL AUTO_INCREMENT,
  `word` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of extend_word
-- ----------------------------
BEGIN;
INSERT INTO `extend_word` (`id`, `word`) VALUES (1, '伍55');
INSERT INTO `extend_word` (`id`, `word`) VALUES (2, '想养一只猫');
COMMIT;

-- ----------------------------
-- Table structure for food
-- ----------------------------
DROP TABLE IF EXISTS `food`;
CREATE TABLE `food` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '名称',
  `type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '种类',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='shi';

-- ----------------------------
-- Records of food
-- ----------------------------
BEGIN;
INSERT INTO `food` (`id`, `name`, `type`) VALUES (1, '1', '1');
INSERT INTO `food` (`id`, `name`, `type`) VALUES (2, '2', '2');
INSERT INTO `food` (`id`, `name`, `type`) VALUES (3, '3', '3');
INSERT INTO `food` (`id`, `name`, `type`) VALUES (4, '4', '4');
COMMIT;

-- ----------------------------
-- Table structure for order
-- ----------------------------
DROP TABLE IF EXISTS `order`;
CREATE TABLE `order` (
  `id` bigint NOT NULL,
  `no` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `create_time` datetime DEFAULT NULL,
  `creator` varchar(10) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of order
-- ----------------------------
BEGIN;
INSERT INTO `order` (`id`, `no`, `address`, `amount`, `create_time`, `creator`) VALUES (2, '12', '11', 8.00, NULL, NULL);
INSERT INTO `order` (`id`, `no`, `address`, `amount`, `create_time`, `creator`) VALUES (1496114197287690242, '12', '', 0.00, NULL, '');
INSERT INTO `order` (`id`, `no`, `address`, `amount`, `create_time`, `creator`) VALUES (1496299498798841857, '123', '贵阳', NULL, NULL, NULL);
INSERT INTO `order` (`id`, `no`, `address`, `amount`, `create_time`, `creator`) VALUES (1496300000181764097, '123', '贵阳', 1000.00, NULL, '管理员');
COMMIT;

-- ----------------------------
-- Table structure for products
-- ----------------------------
DROP TABLE IF EXISTS `products`;
CREATE TABLE `products` (
  `id` bigint NOT NULL,
  `no` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(60) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` decimal(10,2) DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `order_id` bigint DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of products
-- ----------------------------
BEGIN;
INSERT INTO `products` (`id`, `no`, `type`, `quantity`, `price`, `amount`, `order_id`) VALUES (1496117109917257730, '1', '手机', 1.00, 500.00, 500.00, 1496114197287690242);
INSERT INTO `products` (`id`, `no`, `type`, `quantity`, `price`, `amount`, `order_id`) VALUES (1496117111011971074, '2', '手机', 1.00, 500.00, 500.00, 1496114197287690242);
INSERT INTO `products` (`id`, `no`, `type`, `quantity`, `price`, `amount`, `order_id`) VALUES (1496300000248872962, '1', '手机', 1.00, 500.00, 500.00, 1496300000181764097);
INSERT INTO `products` (`id`, `no`, `type`, `quantity`, `price`, `amount`, `order_id`) VALUES (1496300000261455873, '2', '手机', 1.00, 500.00, 500.00, 1496300000181764097);
COMMIT;

-- ----------------------------
-- Table structure for stop_word
-- ----------------------------
DROP TABLE IF EXISTS `stop_word`;
CREATE TABLE `stop_word` (
  `id` int NOT NULL AUTO_INCREMENT,
  `word` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of stop_word
-- ----------------------------
BEGIN;
INSERT INTO `stop_word` (`id`, `word`) VALUES (1, '突然');
INSERT INTO `stop_word` (`id`, `word`) VALUES (2, '这会儿');
COMMIT;

-- ----------------------------
-- Table structure for undo_log
-- ----------------------------
DROP TABLE IF EXISTS `undo_log`;
CREATE TABLE `undo_log` (
  `id` bigint NOT NULL AUTO_INCREMENT COMMENT 'increment id',
  `branch_id` bigint NOT NULL COMMENT 'branch transaction id',
  `xid` varchar(100) NOT NULL COMMENT 'global transaction id',
  `context` varchar(128) NOT NULL COMMENT 'undo_log context,such as serialization',
  `rollback_info` longblob NOT NULL COMMENT 'rollback info',
  `log_status` int NOT NULL COMMENT '0:normal status,1:defense status',
  `log_created` datetime NOT NULL COMMENT 'create datetime',
  `log_modified` datetime NOT NULL COMMENT 'modify datetime',
  PRIMARY KEY (`id`),
  UNIQUE KEY `ux_undo_log` (`xid`,`branch_id`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8mb3 COMMENT='AT transaction mode undo table';

-- ----------------------------
-- Records of undo_log
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  `password` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_id_uindex` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- ----------------------------
-- Records of user
-- ----------------------------
BEGIN;
INSERT INTO `user` (`id`, `name`, `user_name`, `password`) VALUES (1, 'user_1', '1', '1');
INSERT INTO `user` (`id`, `name`, `user_name`, `password`) VALUES (2, 'user_1', '1', '1');
INSERT INTO `user` (`id`, `name`, `user_name`, `password`) VALUES (3, 'user_3', '3', '3');
INSERT INTO `user` (`id`, `name`, `user_name`, `password`) VALUES (7, '管理员', 'root', '123456');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
